package com.simtop.service;

import com.simtop.pojo.*;
import com.simtop.vo.LabVo;

import java.util.ArrayList;
import java.util.List;

public interface SqyxBaseServer {

    public List<SqyxBase> selectAllPeoper();

    public List<SqyxBase> selectAllPeoper2();

    int findCountab(String sex, String membergrade, String cp, Integer startsp, Integer endsp,
                    String profession, String area, String constellation, Integer max, Integer small, Integer dzmax, Integer dzsmall,
                    Integer htmax, Integer htsmall, String fwstarttimes, String fwendtimes, String zcstarttimes, String zcendtimes, Integer kdjmax, Integer kdjsmall, Integer hymax, Integer hysmall,
                    String xq, String newsstarttimes, String newsendtimes, String speakstarttimes, String speakendtimes, String signinstarttimes, String signinendtimes, String cistarttimes, String ciendtimes, String sharestarttimes, String shareendtimes);

    int findCountnew(String starttimes, String endtimes);

    SqyxBase findAllById(int id);

    int gitAllPeoper();

    List<String> findAllByName(String sex,  String membergrade, String cp, Integer startsp, Integer endsp, String profession, String area, String constellation, Integer max, Integer small, Integer dzmax, Integer dzsmall, Integer htmax, Integer htsmall, String fwstarttimes, String fwendtimes, String zcstarttimes, String zcendtimes, Integer kdjmax, Integer kdjsmall, Integer hymax, Integer hysmall, String xq, String newsstarttimes, String newsendtimes, String speakstarttimes, String speakendtimes, String signinstarttimes, String signinendtimes, String cistarttimes, String ciendtimes, String sharestarttimes, String shareendtimes);

    LocalDistributionVo findlocal(List<String> objects);

    List<String> findAllNameNews(String starttimes, String endtimes);

    AgedistributionVo getageDistribution(List<String> objects);

    SexCount gitsex(List<String> objects);

    ConsumptVo getsr(List<String> objects);

    List<SqyxBase> selectAllPeoperByNewTime(String starttimes, String endtimes);

    SexCount findTime(String everday);

    List<NewAreaVo> findarea(String starttimes, String endtimes);

    List<Productvo> findcategoryByDate(String starttimes, String endtimes);

    QdVo findqd(String everday);

    int fincount(String everday);

    List<NewMemberVo> findmamber(String starttimes, String endtimes,List<String> names);

    int findyn(String everday);

    int findtop(String everday);

    int findtoptop(String everday);

    int findtopic(String everday);

    List<NewInere> finInsere(String starttimes, String endtimes);

    int findallshare(String everday);

    int findallpro(String everday);

    List<CyyxVo> finacyyx(String starttimes, String endtimes);

    List<CyyxVo> finacyyxx(String starttimes, String endtimes);

    List<CyyxVo> finacyyxxx(String starttimes, String endtimes);

    double findzh(String everday);

    UserZhVo findregister(String starttimes, String endtimes);

    double findfg(String everday);

    UserZhVo findregisterr(String starttimes, String endtimes);

    NewKdVo finzje(String starttimes, String endtimes);

    NewKdVo findsjcp(String starttimes, String endtimes,String userlb);

    NewKdVo findsjcps(String starttimes, String endtimes, String userlb);

    PcVo finpc(String starttimes, String endtimes);

    PcVo finpcc(String starttimes, String endtimes, String pc);

    List<String> gitlb();

    int findlsrq();

    int findlcrq();

    Float lcqd();

    Float lsqd();

    Float lcfy();

    float lsfy();

    float lcll();

    float lsll();

    float lsxd();

    float lcxd();

    float lsdl();

    float lcdl();

    int finsjsex1(String usersr, String starttimes, String endtimes);

    int finsjsex2(String usersr, String starttimes, String endtimes);

    int finsjsex3(String usersr, String starttimes, String endtimes);

    int finsjcon1(String usersr, String starttimes, String endtimes);

    int finsjcon2(String usersr, String starttimes, String endtimes);

    int finsjcon3(String usersr, String starttimes, String endtimes);

    int finsjedu1(String usersr, String starttimes, String endtimes);

    int finsjedu2(String usersr, String starttimes, String endtimes);

    int finsjedu3(String usersr, String starttimes, String endtimes);

    int finsjarea1(String usersr, String starttimes, String endtimes);

    int finsjarea2(String usersr, String starttimes, String endtimes);

    int finsjarea3(String usersr, String starttimes, String endtimes);

    int finsjcha1(String usersr, String starttimes, String endtimes);

    int finsjcha2(String usersr, String starttimes, String endtimes);

    int finsjcha3(String usersr, String starttimes, String endtimes);

    int finsjsig1(String usersr, String starttimes, String endtimes);

    int finsjsig2(String usersr, String starttimes, String endtimes);

    int finsjsig3(String usersr, String starttimes, String endtimes);

    int finsjmem1(String usersr, String starttimes, String endtimes);

    int finsjmem2(String usersr, String starttimes, String endtimes);

    int finsjmem3(String usersr, String starttimes, String endtimes);

    int finsjmemb1(String usersr, String starttimes, String endtimes);

    int finsjmemb2(String usersr, String starttimes, String endtimes);

    int finsjmemb3(String usersr, String starttimes, String endtimes);


    int findCountlb1(String usersr, String starttimes, String endtimes);

    int findCountlb2(String usersr, String starttimes, String endtimes);

    int findCountlb3(String usersr, String starttimes, String endtimes);

    List<SqyxBase> getAllName();

    int getAllCountss(String topicone, String topictwo, String topicthree);

    List<String> getAllCountsss(String topicone, String topictwo, String topicthree);

    List<SqyxBase> selectAllPeoperByNewTime01(String signin , String starttimes, String endtimes);

    List<SqyxBase> selectAllPeoperByNewTime02(String starttimes, String endtimes);

    List<SqyxBase> selectAllPeoperByNewTime03(String starttimes, String endtimes);

    List<SqyxBase> selectAllPeoperByNewTime04(String starttimes, String endtimes);

    List<NewAreaVo> findareaqd(String starttimes, String endtimes);

    SexCount findTimeqd(String everday);

    List<NewAreaVo> findareafy(String starttimes, String endtimes);

    SexCount findTimefy(String everday);

    List<NewAreaVo> findareaht(String starttimes, String endtimes);

    SexCount findTimeht(String everday);

    List<NewAreaVo> findareafx(String starttimes, String endtimes);

    SexCount findTimefx(String everday);

    List<String> findlsrqls();

    List<String> findlsrqlslc();

    int findCountnewbuy(String usersr, String starttimes, String endtimes);

    int findCountnewbuybig(String usersr, String starttimes, String endtimes);

    int findCountnewbuysmall(String usersr, String starttimes, String endtimes);

    int findlsrqq();


    int findlcrqq();

    List<Sqsy> allsy(int roleId);

    List<Sqsy> allallsy();

    void insertsy(int sqsyuserid, String sqsyname, String sqsysc, String sqsytime, double sqsycj, String sqsypj);

    void deletesy(int sqsyid);

    List<String> getoccupation();

    void tjsy(String sqsyname, Integer sqsyuserid, double sqsycj, String sqsytime, String sqsypj, String sqsysc, String markinfo, String evaluate);

    List<SqyxBase> selectAllPeoperdd();

    int dyage(Integer put);


    int xyage(Integer put);

    int dyagekdj(Integer put);


    int xyagekdj(Integer put);

    int dyagehy(Integer put);


    int xyagehy(Integer put);

    int dyagedz(Integer put);


    int xyagedz(Integer put);

    int dysr(Integer srput);

    int xysr(Integer srput);

    int counttabone(String fwstarttimes, String fwendtimes, String zcstarttimes, String zcendtimes);

    int counttabone1(String fwstarttimes, String fwendtimes);

    int counttabone2(String zcstarttimes, String zcendtimes);

    String findlast(String zctime);


    int findAllkdja(String productcategoryone);

    int findAllkdjb(String productcategorytwo);

    int findAllkdjc(String productcategorythree);

    List<Sqsy> findAllUserList(ArrayList<Integer> sqsyidlist);

    List<Sqsy> findAllUserList1();

    LabVo finOneLable(String age);

    List<SqyxBase> selectAge(String fh, Integer put);

    List<SqyxBase> selectAgeSex(String fh, Integer put , String sex);


    List<SqyxBase> selectSru(String fh, Integer put);

    List<SqyxBase> selectSruSex(String fh, Integer put,String sex);

    List<SqyxBase> selectHy(String fh, Integer put);

    List<SqyxBase> selectHysex(String fh, Integer put,String sex);


    List<SqyxBase> selectDz(String fh, Integer put);

    List<SqyxBase> selectDzsex(String fh, Integer put , String sex);


    List<SqyxBase> selectKdj(String fh, Integer put);

    List<SqyxBase> selectKdjsex(String fh, Integer put,String sex);


    List<SqyxBase> selectfwtime(String fwstarttimes, String fwendtimes);

    List<SqyxBase> selectfwtime2(String fwstarttimes, String fwendtimes);

    List<SqyxBase> selectSex(String sex);

    List<SqyxBase> selectArea(String city);

    List<SqyxBase> selectprofession(String profession);

    List<SqyxBase> selectconstellation(String constellation);

    List<SqyxBase> selectmembergrade(String membergrade);

    List<SqyxBase> selectpreference(String preference);

    List<SqyxBase> selectpreference2(String preference);

    List<SqyxBase> selectnewxz(String newsstarttimes, String newsendtimes);

    List<SqyxBase> selectqd(String newsstarttimes, String newsendtimes);

    List<SqyxBase> selectAgeandSr(String fh, Integer put, String fh2, Integer put2);

    List<SqyxBase> selectAgeandSr2(String fh, Integer put, String fh2, Integer put2);

    List<SqyxBase> selectAgeandSr3(String fh, Integer put, String fh2, Integer put2);

    List<SqyxBase> selectAgeandSr4(String fh, Integer put, String fh2, Integer put2);

}
